https://store-images.s-microsoft.com/image/apps.35702.bd5bfae5-13cd-4241-829c-20b29bd858d0.e7271cce-db8e-4d84-aefd-edca26d6afd2.eda58493-998a-4df8-aeb4-fe7a94a8d096

Data Import and Transformation Tool

by Capgemini New Zealand Limited

Free trial badge

Import Excel, CSV, Json, and other data files into Journals and other tables using an import wizard.

Capgemini's Data Import and Transformation Tool streamlines the importing process of transactional data and allows the user to save the mappings for reuse. It is available on most journal pages and can also be run from the menu to load data into any table.

Data exchange definitions can also be applied to the mappings to allow the import of xml files, and transformation rules can be created to assist with mapping of data to new values saving the need to manipulate in excel prior to loading.

Supported Editions

This app supports the Essential and Premium editions of Dynamics 365 Business Central.

Supported Countries

Australia, New Zealand, and United Kingdom.

Supported Languages

This app is available in English (New Zealand), English (Australian), English (United States), and English (United Kingdom).

At a glance

https://store-images.s-microsoft.com/image/apps.56646.bd5bfae5-13cd-4241-829c-20b29bd858d0.d750ee90-9887-4e11-9fbe-1bc396190f3a.d0755c22-4e3a-4d84-87ba-4e620bb37eb4
https://store-images.s-microsoft.com/image/apps.44035.bd5bfae5-13cd-4241-829c-20b29bd858d0.d750ee90-9887-4e11-9fbe-1bc396190f3a.0ca53764-a3a8-467a-a3a2-fe1a520f5594
https://store-images.s-microsoft.com/image/apps.61605.bd5bfae5-13cd-4241-829c-20b29bd858d0.d750ee90-9887-4e11-9fbe-1bc396190f3a.c48e963a-a7c1-4bf5-810f-04064ad0b492